select count(measuremen0_.id) as col_0_0_, resource2_.ID as col_1_0_,
measuremen1_.id as col_2_0_, resource2_.NAME as col_3_0_, measuremen3_.name as col_4_0_
from RHQ_MEASUREMENT_OOB measuremen0_
inner join RHQ_MEASUREMENT_SCHED measuremen1_ on measuremen0_.SCHEDULE_ID=measuremen1_.id
inner join RHQ_RESOURCE resource2_ on measuremen1_.RESOURCE_ID=resource2_.ID,
RHQ_MEASUREMENT_DEF measuremen3_
where measuremen1_.DEFINITION=measuremen3_.ID
group by resource2_.ID , measuremen1_.id , resource2_.NAME , measuremen3_.name
order by count(measuremen0_.id) desc